package com.dingding.service.user.core.sql;

/**
 * 
 * @ClassName: TaxiGrabOrderSQL 
 * @Description: 出租车抢单SQL公共类 
 * @author YHQ
 * @date 2016年6月30日 下午4:56:01
 * 
 */
public class TaxiGrabOrderSQL {

	/**
	 * 乘客抢单查看对方用户信息SQL
	 * 
	 * @author YHQ
	 */
	public static final String PASSAGER_GRABORDER_GET_USER_INFO = "SELECT pu.aliasId,pu.userName,pu.loginEquipment,ud.nickName,ud.sex,ud.tellphone,ud.userAvatar,ud.userTabloidAvatar,vi.vehicleType,vi.vehicleModel,vi.vehicleColor,vi.vehicleImage,vi.lisencePlate,ud.userLevel FROM userlogin u INNER JOIN userdetail ud ON ud.loginId = u.uid INNER JOIN vehicleinfo vi ON vi.loginId = ud.loginId INNER JOIN userlogin pu ON pu.uid = ? INNER JOIN userdetail pud ON pu.uid = pud.loginId WHERE u.uid = ?";

	/**
	 * 司机抢单查看对方用户信息SQL
	 * 
	 * @author hufan
	 */
	public static final String DRIVER_GRABORDER_GET_USER_INFO = "SELECT pu.aliasId,pu.userName,pu.loginEquipment,ud.nickName,ud.sex,ud.telPhone,ud.userAvatar,ud.userTabloidAvatar,vi.vehicleType,vi.vehicleModel,vi.vehicleColor,vi.vehicleImage,vi.lisencePlate,ud.userLevel FROM specialuserlogin u INNER JOIN specialuserinfo ud ON ud.userId = u.suid INNER JOIN specialuservehicleinfo vi ON vi.userId = ud.userId INNER JOIN userlogin pu ON pu.uid = ? INNER JOIN userdetail pud ON pu.uid = pud.loginId WHERE u.suid = ?";

}
